package com.koron.css2.meterService.mapper;

import com.koron.css2.meterService.bean.MsInfoPlanDetailBean;
import com.koron.css2.meterService.bean.query.MsInfoPlanDetailQueryBean;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface MsInfoPlanDetailMapper {
	
	List<MsInfoPlanDetailBean> selectMsInfoPlanDetailList(MsInfoPlanDetailQueryBean query);
	
	MsInfoPlanDetailBean selectByFactoryNo(String factoryNo);

	int countByImsi(String imsi);

	int countByImei(String imei);

	MsInfoPlanDetailBean selectFromPlanDetailByFactoryNo(String factoryNo);
	
	List<MsInfoPlanDetailBean> selectByReceiptId(String receiptId);
	
	int addMsInfoPlanDetail(MsInfoPlanDetailBean bean);
	
	int updateCheckState(@Param("id") String id, @Param("checkState") int checkState);
	
	int updateMsInfoPlanDetail(MsInfoPlanDetailBean bean);
	
	int deleteById(String id);
	
	int deleteByReceiptId(String receiptId);

}
